[dbo].[asi_WorkflowInstanceAppendLog]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@instanceKey	uniqueidentifier	16
@textToAppend	nvarchar(4000)	8000

SQL Script

CREATE  proc [dbo].[asi_WorkflowInstanceAppendLog]
@instanceKey uniqueidentifier,
@textToAppend nvarchar(4000) as

DECLARE @ptr varbinary(16)

SELECT  @ptr = TEXTPTR(LogText)
FROM   WorkflowInstance
WHERE  WorkflowInstanceKey = @instanceKey
IF TEXTVALID('WorkflowInstance.LogText', @ptr) = 1
BEGIN
   UPDATETEXT WorkflowInstance.LogText @ptr NULL 0 @textToAppend --Append to end
   --UPDATETEXT WorkflowInstance.LogText @ptr 0 0 @textToAppend --Insert at beginning
END
ELSE
BEGIN
   UPDATE WorkflowInstance
      SET LogText = @textToAppend
    WHERE WorkflowInstanceKey = @instanceKey
END

GO